package com.yuanqi.mapper;

import com.yuanqi.entity.Inventory;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
* @author HP
* @description 针对表【inventory(库存余额)】的数据库操作Mapper
* @createDate 2025-08-27 11:07:31
* @Entity com.yuanqi.entity.Inventory
*/
public interface InventoryMapper extends BaseMapper<Inventory> {

    /**
     * 获取库存统计列表
     */
    List<Map<String, Object>> selectInventoryStatsList(Map<String, Object> params);

    /**
     * 获取库存统计总数
     */
    long selectInventoryStatsCount(Map<String, Object> params);

    /**
     * 获取库存统计数据
     */
    Map<String, Object> selectInventoryStats(Map<String, Object> params);

    /**
     * 根据状态获取库存统计数量
     */
    long selectInventoryStatsCountByStatus(Map<String, Object> params, @Param("status") String status);

    /**
     * 获取库存统计概览
     */
    Map<String, Object> selectInventoryOverview(Map<String, Object> params);

    /**
     * 获取仓库库存价值分布数据
     */
    List<Map<String, Object>> selectWarehouseValueData(Map<String, Object> params);

    /**
     * 获取商品分类库存数量分布数据
     */
    List<Map<String, Object>> selectCategoryQuantityData(Map<String, Object> params);
}




